[dbo].[MailCodeRef]

Property	Value
Created	10:31:27 AM Tuesday, March 02, 2010
Last Modified	1:20:15 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)
MailCode	nvarchar(5)	10
MailCodeDesc	nvarchar(50)	100
UpdatedOn	datetime	8
UpdatedByUserKey	uniqueidentifier	16

	Name	Columns	Unique
	PK_MailCodeRef	MailCode
	AK_MailCodeRef_MailCodeDesc	MailCodeDesc
	IX_MailCodeRef_UpdatedByUserKey	UpdatedByUserKey

Name	Columns
FK_MailCodeRef_UserMain_UpdatedBy	UpdatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[MailCodeRef]
(
[MailCode] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailCodeDesc] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MailCodeRef] ADD CONSTRAINT [PK_MailCodeRef] PRIMARY KEY CLUSTERED ([MailCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MailCodeRef] ADD CONSTRAINT [AK_MailCodeRef_MailCodeDesc] UNIQUE NONCLUSTERED ([MailCodeDesc]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MailCodeRef_UpdatedByUserKey] ON [dbo].[MailCodeRef] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MailCodeRef] ADD CONSTRAINT [FK_MailCodeRef_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO